# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月19日
"""
import openpyxl

myBook = openpyxl.load_workbook('员工表.xlsx')
myList = list(map(lambda myCell3,myCell4: myCell3.value+myCell4.value,
                  list(myBook.active.columns)[3][1:],
                  list(myBook.active.columns)[4][1:]))
myIndex = 0
for myCell in list(myBook.active.columns)[5][1:]:
	myCell.value = myList[myIndex]
	myIndex += 1
myBook.save('结果表-员工表.xlsx')
